Tabela InsuranceCheckLog

Definicja tabeli InsuranceCheckLog

Name

InsuranceCheckLog

Code

InsuranceCheckLog

Comment

Log czynnosci weryfikacji ubezpieczenia


Lista kolumn tabeli InsuranceCheckLog

Name

Code

InsuranceCheckLogID

InsuranceCheckLogID

InsuranceCheckResultID

InsuranceCheckResultID

InsuranceDocumentTypeID

InsuranceDocumentTypeID

LPatientInsurerID

LPatientInsurerID

InsurID

InsurID

PersonID

PersonID

StartDT

StartDT

StopDT

StopDT


Kolumna InsuranceCheckLogID tabeli InsuranceCheckLog

Definicja kolumny InsuranceCheckLogID tabeli InsuranceCheckLog

Name

InsuranceCheckLogID

Code

InsuranceCheckLogID

Data Type

NUMBER(10)

Mandatory

Yes

Comment

ID logu czynnosci weryfikacji ubezpieczenia


Kolumna InsuranceCheckResultID tabeli InsuranceCheckLog

Definicja kolumny InsuranceCheckResultID tabeli InsuranceCheckLog

Name

InsuranceCheckResultID

Code

InsuranceCheckResultID

Data Type

NUMBER(10)

Mandatory

Yes

Comment

ID wyniku weryfikacji ubezpieczenia


Kolumna InsuranceDocumentTypeID tabeli InsuranceCheckLog

Definicja kolumny InsuranceDocumentTypeID tabeli InsuranceCheckLog

Name

InsuranceDocumentTypeID

Code

InsuranceDocumentTypeID

Data Type

NUMBER(10)

Mandatory

No

Comment

Rodzaj dokumentu


Kolumna LPatientInsurerID tabeli InsuranceCheckLog

Definicja kolumny LPatientInsurerID tabeli InsuranceCheckLog

Name

LPatientInsurerID

Code

LPatientInsurerID

Data Type

NUMBER(10)

Mandatory

No

Comment

Ubezpieczenie pacjenta


Kolumna InsurID tabeli InsuranceCheckLog

Definicja kolumny InsurID tabeli InsuranceCheckLog

Name

InsurID

Code

InsurID

Data Type

NUMBER(10)

Mandatory

No

Comment

Ubezpieczyciel


Kolumna PersonID tabeli InsuranceCheckLog

Definicja kolumny PersonID tabeli InsuranceCheckLog

Name

PersonID

Code

PersonID

Data Type

NUMBER(10)

Mandatory

Yes

Comment

Pacjent


Kolumna StartDT tabeli InsuranceCheckLog

Definicja kolumny StartDT tabeli InsuranceCheckLog

Name

StartDT

Code

StartDT

Data Type

DATE

Mandatory

No

Comment

 


Kolumna StopDT tabeli InsuranceCheckLog

Definicja kolumny StopDT tabeli InsuranceCheckLog

Name

StopDT

Code

StopDT

Data Type

DATE

Mandatory

No

Comment

 


Lista kluczy tabeli InsuranceCheckLog

Name

Code

Primary

Identifier_1

Identifier_1

X


Klucz Identifier_1 tabeli InsuranceCheckLog

Definicja klucza Identifier_1 tabeli InsuranceCheckLog

Name

Identifier_1

Code

Identifier_1

Primary

Yes

Comment